import csv
import pandas as pd
import numpy as np
import sys

#
x = np.random.random(100)
y = np.random.random(100)
z = np.random.random(100)
# for i in range(0, 9):
#     sys.stdout.write("\'lp_number%s\'," % i)
df=pd.DataFrame(np.random.rand(500,200)/9,columns=['cpu0','cpu1','cpu2','cpu3','cpu4','cpu5','cpu6','cpu7','cpu8','cpu9','cpu10','cpu11','cpu12','cpu13','cpu14','cpu15','cpu16','cpu17','cpu18','cpu19','cpu20','cpu21','cpu22','cpu23','cpu24','cpu25','cpu26','cpu27','cpu28','cpu29','cpu30','cpu31','cpu32','cpu33','cpu34','cpu35','cpu36','cpu37','cpu38','cpu39','cpu40','cpu41','cpu42','cpu43','cpu44','cpu45','cpu46','cpu47','cpu48','cpu49','cpu50','cpu51','cpu52','cpu53','cpu54','cpu55','cpu56','cpu57','cpu58','cpu59','cpu60','cpu61','cpu62','cpu63','cpu64','cpu65','cpu66','cpu67','cpu68','cpu69','cpu70','cpu71','cpu72','cpu73','cpu74','cpu75','cpu76','cpu77','cpu78','cpu79','cpu80','cpu81','cpu82','cpu83','cpu84','cpu85','cpu86','cpu87','cpu88','cpu89','cpu90','cpu91','cpu92','cpu93','cpu94','cpu95','cpu96','cpu97','cpu98','cpu99','mem0','mem1','mem2','mem3','mem4','mem5','mem6','mem7','mem8','mem9','mem10','mem11','mem12','mem13','mem14','mem15','mem16','mem17','mem18','mem19','mem20','mem21','mem22','mem23','mem24','mem25','mem26','mem27','mem28','mem29','mem30','mem31','mem32','mem33','mem34','mem35','mem36','mem37','mem38','mem39','mem40','mem41','mem42','mem43','mem44','mem45','mem46','mem47','mem48','mem49','mem50','mem51','mem52','mem53','mem54','mem55','mem56','mem57','mem58','mem59','mem60','mem61','mem62','mem63','mem64','mem65','mem66','mem67','mem68','mem69','mem70','mem71','mem72','mem73','mem74','mem75','mem76','mem77','mem78','mem79','mem80','mem81','mem82','mem83','mem84','mem85','mem86','mem87','mem88','mem89','mem90','mem91','mem92','mem93','mem94','mem95','mem96','mem97','mem98','mem99'])
# print(df.values)

df2=pd.DataFrame(np.random.random_integers(0,8,size = (500,100)),columns=['vm_loc0','vm_loc1','vm_loc2','vm_loc3','vm_loc4','vm_loc5','vm_loc6','vm_loc7','vm_loc8','vm_loc9','vm_loc10','vm_loc11','vm_loc12','vm_loc13','vm_loc14','vm_loc15','vm_loc16','vm_loc17','vm_loc18','vm_loc19','vm_loc20','vm_loc21','vm_loc22','vm_loc23','vm_loc24','vm_loc25','vm_loc26','vm_loc27','vm_loc28','vm_loc29','vm_loc30','vm_loc31','vm_loc32','vm_loc33','vm_loc34','vm_loc35','vm_loc36','vm_loc37','vm_loc38','vm_loc39','vm_loc40','vm_loc41','vm_loc42','vm_loc43','vm_loc44','vm_loc45','vm_loc46','vm_loc47','vm_loc48','vm_loc49','vm_loc50','vm_loc51','vm_loc52','vm_loc53','vm_loc54','vm_loc55','vm_loc56','vm_loc57','vm_loc58','vm_loc59','vm_loc60','vm_loc61','vm_loc62','vm_loc63','vm_loc64','vm_loc65','vm_loc66','vm_loc67','vm_loc68','vm_loc69','vm_loc70','vm_loc71','vm_loc72','vm_loc73','vm_loc74','vm_loc75','vm_loc76','vm_loc77','vm_loc78','vm_loc79','vm_loc80','vm_loc81','vm_loc82','vm_loc83','vm_loc84','vm_loc85','vm_loc86','vm_loc87','vm_loc88','vm_loc89','vm_loc90','vm_loc91','vm_loc92','vm_loc93','vm_loc94','vm_loc95','vm_loc96','vm_loc97','vm_loc98','vm_loc99'])
# print(df)
df3=pd.concat([df,df2],join="inner",axis=1)
# print(df3)
# ###df3.to_csv('1.csv')
# df4=pd.DataFrame(
#              columns=['cpu_percent0', 'cpu_percent1', 'cpu_percent2', 'cpu_percent3', 'cpu_percent4', 'cpu_percent5',
#                       'cpu_percent6', 'cpu_percent7', 'cpu_percent8', 'mem_percent0', 'mem_percent1', 'mem_percent2',
#                       'mem_percent3', 'mem_percent4', 'mem_percent5', 'mem_percent6', 'mem_percent7', 'mem_percent8','lp_number0', 'lp_number1', 'lp_number2', 'lp_number3', 'lp_number4', 'lp_number5', 'lp_number6',
#                       'lp_number7', 'lp_number8' ])




